package com.qc.entity;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

public class UserSecretaryEntity extends UserEntity {
	
	protected long secUserId;
	protected String secHeight;
	protected double heightPrice;//身高价格
	protected String education;
	protected double educationPrice;//学历价格
	protected String specialty;
	protected double specialtyPrice;//专业价格
	protected String job;
	protected double jobPrice;//职业价格
	protected String tagIds;
	protected double tagPrice;//技能价格
	protected double moneyDay;//总金额
	protected String jobArea;
	protected String nationality;
	protected String nation;
	protected String bloodStyle;
	protected String liveProvince;
	protected String liveCity;
	protected String homeProvince;
	protected String homeCity;
	protected String school;
	protected String intro;
//	protected String video;
	protected String secFrontPhoto;
	protected String secFullPhoto;
	protected String secLivePhoto;
	
	//气质特征
	private String bName;
	
	//商家id
	private long shopId;
	
	//交易数
	private int transactionNumber;
	
	protected List<UserSecScheduleEntity> ssList;
	protected List<OrderCommentEntity> ocList;
	protected int isFollowed;//是否关注 1/已关注
	protected int isOrdered;//是否有订单关系 1/有订单关系
	
	protected float grade;//订单评分
	
	protected long videoId;//微视频表id
	
	//认证状态 0 提交  1 通过 2 拒绝
	private int type;
	
	public static UserSecretaryEntity getInstance(ResultSet rs) throws SQLException {
		UserSecretaryEntity entity = new UserSecretaryEntity();

		entity.setSecHeight(rs.getString("sec_height"));
		entity.setEducation(rs.getString("education"));
		entity.setSpecialty(rs.getString("specialty"));
		entity.setJob(rs.getString("job"));
		entity.setTagIds(rs.getString("tag_ids"));
		entity.setMoneyDay(rs.getDouble("money_day"));
		entity.setJobArea(rs.getString("job_area"));
		entity.setNationality(rs.getString("nationality"));
		entity.setNation(rs.getString("nation"));
		entity.setBloodStyle(rs.getString("blood_style"));
		entity.setLiveProvince(rs.getString("live_province"));
		entity.setLiveCity(rs.getString("live_city"));
		entity.setHomeProvince(rs.getString("home_province"));
		entity.setHomeCity(rs.getString("home_city"));
		entity.setSchool(rs.getString("school"));
		entity.setIntro(rs.getString("intro"));
//		entity.setVideo(rs.getString("video"));
		entity.setSecFrontPhoto(rs.getString("sec_front_photo"));
		entity.setSecFullPhoto(rs.getString("sec_full_photo"));
		entity.setSecLivePhoto(rs.getString("sec_live_photo"));
		entity.setAvatar(rs.getString("avatar"));
		entity.setNickname(rs.getString("nickname"));
		entity.setUserAge(rs.getString("user_age"));
		entity.setSex(rs.getString("sex"));
		entity.setSecUserId(rs.getInt("user_id"));
		entity.setIsFollowed(rs.getInt("isFollowed"));
		entity.setIsOrdered(rs.getInt("isOrdered"));
		entity.setVideoId(rs.getLong("video_id"));
		try {
			entity.setGrade(rs.getFloat("grade"));
		} catch (Exception e) {
		}
		
		try {
			entity.setHeightPrice(rs.getDouble("height_price"));
			entity.setEducationPrice(rs.getDouble("education_price"));
			entity.setSpecialtyPrice(rs.getDouble("specialty_price"));
			entity.setJobPrice(rs.getDouble("job_price"));
			entity.setTagPrice(rs.getDouble("tag_price"));
		} catch (Exception e) {
		}
		
		try {
			entity.setbName(rs.getString("b_name"));
		} catch (Exception e) {
		}
		
		try {
			entity.setTransactionNumber(rs.getInt("transaction_number"));
		} catch (Exception e) {
		}
		
		try {
			entity.setOrdersState(rs.getInt("orders_state"));
		} catch (Exception e) {
		}
		
		try {
			entity.setType(rs.getInt("type"));
		} catch (Exception e) {
		}
		
		return entity;
	}
	
	public String getSecHeight() {
		return secHeight;
	}
	public void setSecHeight(String secHeight) {
		this.secHeight = secHeight;
	}
	public String getEducation() {
		return education;
	}
	public void setEducation(String education) {
		this.education = education;
	}
	public String getSpecialty() {
		return specialty;
	}
	public void setSpecialty(String specialty) {
		this.specialty = specialty;
	}
	public String getJob() {
		return job;
	}
	public void setJob(String job) {
		this.job = job;
	}
	public String getTagIds() {
		return tagIds;
	}
	public void setTagIds(String tagIds) {
		this.tagIds = tagIds;
	}
	public double getMoneyDay() {
		return moneyDay;
	}
	public void setMoneyDay(double moneyDay) {
		this.moneyDay = moneyDay;
	}
	public String getJobArea() {
		return jobArea;
	}
	public void setJobArea(String jobArea) {
		this.jobArea = jobArea;
	}
	public String getNationality() {
		return nationality;
	}
	public void setNationality(String nationality) {
		this.nationality = nationality;
	}
	public String getNation() {
		return nation;
	}
	public void setNation(String nation) {
		this.nation = nation;
	}
	public String getBloodStyle() {
		return bloodStyle;
	}
	public void setBloodStyle(String bloodStyle) {
		this.bloodStyle = bloodStyle;
	}
	public String getLiveProvince() {
		return liveProvince;
	}
	public void setLiveProvince(String liveProvince) {
		this.liveProvince = liveProvince;
	}
	public String getLiveCity() {
		return liveCity;
	}
	public void setLiveCity(String liveCity) {
		this.liveCity = liveCity;
	}
	public String getSchool() {
		return school;
	}
	public void setSchool(String school) {
		this.school = school;
	}
	public String getIntro() {
		return intro;
	}
	public void setIntro(String intro) {
		this.intro = intro;
	}
//	public String getVideo() {
//		return video;
//	}
//	public void setVideo(String video) {
//		this.video = video;
//	}
	public String getSecFrontPhoto() {
		return secFrontPhoto;
	}
	public void setSecFrontPhoto(String secFrontPhoto) {
		this.secFrontPhoto = secFrontPhoto;
	}
	public String getSecFullPhoto() {
		return secFullPhoto;
	}
	public void setSecFullPhoto(String secFullPhoto) {
		this.secFullPhoto = secFullPhoto;
	}
	public String getSecLivePhoto() {
		return secLivePhoto;
	}
	public void setSecLivePhoto(String secLivePhoto) {
		this.secLivePhoto = secLivePhoto;
	}
	public String getHomeProvince() {
		return homeProvince;
	}
	public void setHomeProvince(String homeProvince) {
		this.homeProvince = homeProvince;
	}
	public String getHomeCity() {
		return homeCity;
	}
	public void setHomeCity(String homeCity) {
		this.homeCity = homeCity;
	}

	public long getSecUserId() {
		return secUserId;
	}

	public void setSecUserId(long secUserId) {
		this.secUserId = secUserId;
	}

	public List<UserSecScheduleEntity> getSsList() {
		return ssList;
	}

	public void setSsList(List<UserSecScheduleEntity> ssList) {
		this.ssList = ssList;
	}

	public int getIsFollowed() {
		return isFollowed;
	}

	public void setIsFollowed(int isFollowed) {
		this.isFollowed = isFollowed;
	}

	public int getIsOrdered() {
		return isOrdered;
	}

	public void setIsOrdered(int isOrdered) {
		this.isOrdered = isOrdered;
	}

	public List<OrderCommentEntity> getOcList() {
		return ocList;
	}

	public void setOcList(List<OrderCommentEntity> ocList) {
		this.ocList = ocList;
	}

	public float getGrade() {
		return grade;
	}

	public void setGrade(float grade) {
		this.grade = grade;
	}

	public long getVideoId() {
		return videoId;
	}

	public void setVideoId(long videoId) {
		this.videoId = videoId;
	}

	public double getHeightPrice() {
		return heightPrice;
	}

	public void setHeightPrice(double heightPrice) {
		this.heightPrice = heightPrice;
	}

	public double getEducationPrice() {
		return educationPrice;
	}

	public void setEducationPrice(double educationPrice) {
		this.educationPrice = educationPrice;
	}

	public double getSpecialtyPrice() {
		return specialtyPrice;
	}

	public void setSpecialtyPrice(double specialtyPrice) {
		this.specialtyPrice = specialtyPrice;
	}

	public double getJobPrice() {
		return jobPrice;
	}

	public void setJobPrice(double jobPrice) {
		this.jobPrice = jobPrice;
	}

	public double getTagPrice() {
		return tagPrice;
	}

	public void setTagPrice(double tagPrice) {
		this.tagPrice = tagPrice;
	}

	public String getbName() {
		return bName;
	}

	public void setbName(String bName) {
		this.bName = bName;
	}

	public long getShopId() {
		return shopId;
	}

	public void setShopId(long shopId) {
		this.shopId = shopId;
	}

	public int getTransactionNumber() {
		return transactionNumber;
	}

	public void setTransactionNumber(int transactionNumber) {
		this.transactionNumber = transactionNumber;
	}

	public int getType() {
		return type;
	}

	public void setType(int type) {
		this.type = type;
	}
	
	
}
